select * from products where pro_name like '%color%ment%' or pro_des like '%color%ment%'union all select * from products where (pro_name like '%color%' or pro_des like '%color%') or(pro_name like '%ment%' or pro_des like '%ment%') and (pro_name not like '%color%ment%' or pro_des not like '%color%ment%')
Coral Red Taffeta Quince Dress with Embroidery and Appliques
Red and White Quinceanera Dress with Embroidery and Appliques
Most Popular Multi-color Sweetheart Quinceanera Dress with Beading
Multi-color One Shoulder Quinceanera Gown Dress with Ruffles
Red and Green Strapless Quinceanera Dress with Appliques and Beading
Green and Red Sweetheart Dress For Quince with Appliques and Ruches
Yellow Green Sweetheart Quinceanera Gown Dress with White Appliques
Purple and Black Strapless Quinceanera Dress with Beading and Ruffled Skirt
Blue and Pink Sweet 16 Quinceanera Dresses with Appliques and Flowers
Multi-color Strapless Quinceanera Dress with Appliques and Ruffles for 2013
Spring Green Sweetheart Quinceanera Dresses with Beading and Pick-ups
Hot Pink and Black Sweet Sixteen Quinceanera Dresses by Taffeta and Tulle
Spring Green and Black Quinceanera Dress with Beaded Waist and Ruches
Lime Green and Black Quinceanera Dress with Appliques and Layered Skirt
Multi-color Zebra Print Decorated Quinceanera Dress with One Shoulder Neck
Neon Green and Black Quinceanera Gown with Bow and Ruffled Skirt Keyshia Coles dress
2013 Lavender and Black Quinceanera Dress with Appliques and Ruches
Multi-color Quinceanera Gowns with Beading and Ruffled Skirt by Tulle
Blue Quinceanera Gown with Embroidery and Straps Decorate Waist Part
Lavender Sweetheart Quinceanera Dress with Embroidery and Beading
2014 Lime Green Quinceanera Dress with Bodice Made by Sequined Fabric
Spring Green Ball Gown Floor-length Quinceanera Dresses
Beaded Yellow Green Quinceneara Dresses with Ruches and Appliques
Light Blue Strapless Floor-length Dresses for Quinceneara
Yellow Ball Gown Quinceanera Dresses with Hand-made Flowers
Multi-color Ball Gown Ruffled Organza Quinceneara Dresses
Beaded Multi-color Organza Sweet 15 Dresses with Ruffles
Multi-color Strapless Floor-length Sweet 15 Dresses with Ruffles
Blue and Black V-neck Quinceneara Dresses with Appliques
Spring Green and Black V-neck Sweet Sixteen Dresses with Appliques